JCapper Message Board

JCapper 101
-- Help - sql expression - claimed horses

Home	Register Log In

Help - sql expression - claimed horses

jeff
10/28/2015
5:10:41 PM

From the email inbox:

--quote:

"Jeff, Is there a way to make a sql expression flag horses that have been recently claimed?"

--end quote

--my reply:

Here's a link to the StarterHistory Table Schema:
http://www.jcapper.com/helpdocs/starterhistorytableschema.html

--quote:

"

Field Name Data Type Description
--------------------- ------------- ----------------------------------------------
claimraces number integer claim races (0=not claimed, 1=claimed last start, 2=claimed 2 back, etc.)
claimdays number integer days since claim (0=not claimed, 19=claimed 19 days ago)
"

--end quote

The field names in the table that you want to work with are claimraces and claimdays. The values in those fields allow you to evaluate and set factor contraints for a horse's three most recent starts.

Examples:

To make a sql expression flag horses that were claimed in their most recent start, add the following line:

AND CLAIMRACES = 1

To make a sql expression flag horses that were claimed in their most recent start and claimed within 110 days of today's race - add the following two lines:

AND CLAIMRACES = 1
AND CLAIMDAYS <= 110

To make a sql expression flag horses that were claimed in their second start back, add the following line:

AND CLAIMRACES = 2

To make a sql expression flag horses that were both claimed in their second start back and claimed within 110 days of today's race - add the following two lines:

AND CLAIMRACES = 2
AND CLAIMDAYS <= 110

To make a sql expression flag horses that were claimed in their third start back, add the following line:

AND CLAIMRACES = 3

To make a sql expression flag horses that were both claimed in their third start back and claimed within 110 days of today's race - add the following two lines:

AND CLAIMRACES = 3
AND CLAIMDAYS <= 110

To make a sql expression flag horses that are trained by a trainer whose name in your data files is "LEVINE BRUCE N" (without the quotes) but only when his horses were claimed in their third start back and claimed within 110 days of today's race - add the following three lines:

AND TRAINER = 'LEVINE BRUCE N'
AND CLAIMRACES = 3
AND CLAIMDAYS <= 110

Note: There's nothing magic about claimed 3 back and/or claimed within the past 110 days, etc.

These are just examples intended to illustrate how to set factor constraints for claimraces and claimdays in a sql expression.

Feel free to use your own cutoffs and/or cutoffs suggested by what you see in the Data Window.

-jp

.

jeff
10/29/2015
8:30:47 AM

From the email inbox:

--quote:

"What about claims in playlist file mode?"

--end quote

--my reply:

Link to the Supported Factors page at JCapper.com:
http://www.jcapper.com/factorsglossary.asp

The factors you want to work with are ClaimDays and ClaimRacesBack.

--quote:

"ClaimDays - This is the number in days, representing the most recent running line looking backwards through a horse's past performance record, where the line for that start shows that a horse was claimed out of that race. Some examples: If none of the running lines in a horse's past performance record show that the horse was claimed then ClaimDays is equal to zero. If a horse was claimed out of its most recent start, and that start was 29 days ago, then ClaimDays is equal to 29. If a horse was claimed in both its second race back (45 days ago) and its fourth race back (111 days ago) then ClaimDays is equal 45. When more than one running line shows a claim, ClaimDays is taken from the most recent race showing a claim. The idea is to identify the how many days ago a horse was claimed by its current trainer. Hint~ This information can be useful when creating Trainer Specific UDMs. Some trainers really excel with horses making their first start for the new barn within X days of the claim, while others have dismal historical records with their recently claimed horses. (Accessible via the Profile Table Interface)

ClaimRacesBack - This is a number that represents the most recent running line looking backwards through a horse's past performance record that shows a horse was claimed out of that race. Some examples: If none of the running lines in a horse's past performance record show that the horse was claimed then ClaimRacesBack is equal to zero. If a horse was claimed out of its most recent start then ClaimRacesBack is equal to one. If a horse was claimed in both its second race back and its fourth race back, then ClaimRacesBack is equal to two. The idea is to identify the how many races back a horse was claimed by its current trainer. Hint~ This information can be useful when creating Trainer Specific UDMs. Some trainers really excel with horses first or second off the claim, while others have dismal historical records with their recently claimed horses. (Accessible via the Profile Table Interface)"

--end quote

To set factor constraints for ClaimRacesBack or ClaimDays in a Playlist File Mode UDM:

1. Bring up a Playlist File Mode UDM in the UDM Wizard's Modify UDM Screen.

2. Select "Claimed (races and days)" (without the quotes) from the Factors Drop Down.

3. Check the Test Box.

4. Key in values for Min Races and Max Races.

Example: To make the UDM flag horses claimed in their most recent start key "1" (without the quotes) into the Min Races field and key "1" (without the quotes) into the Max Races field.

5. Key in values for Min Days and Max Days.

Example: To set a ClaimDays constraint and make the UDM flag horses claimed within 110 days of today's race key "1" (without the quotes) into the Min Days field and key "110" (without the quotes) into the Max Days field.

Note: If you don't want the UDM to have a ClaimDays constraint, just go with the defaults or key "-999" (without the quotes) into the Min Days field and key "999" (without the quotes) into the Max Days field.

6. Click the SAVE button.

7. Run the UDM through the Data Window with the data broken out by both Claimed Races Back and Claimed Days Back to check your work.

That's it!

-jp

.

JCapper Message Board

JCapper 101 -- Help - sql expression - claimed horses

JCapper 101
-- Help - sql expression - claimed horses